﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace libAddressBook.BUS
{
    public class clsBUSFindCompany : IDisposable 
    {
        private clsFindCompanyQuery _Queries;

        public clsBUSFindCompany()
        {
            _Queries = new clsFindCompanyQuery();
        }



        public void Dispose()
        {
            GC.Collect();
           // throw new NotImplementedException();
        }
    }

    public sealed class clsFindCompanyQuery : IDisposable 
    {

        public string get_queryCustomerList()
        {
            return "SELECT comid, oldcomid, portid, comregno, comname, comname2, addbookcode, induscode, website, addline1, addline2, addline3, addline4, areacode, citycode, stacode, " +
                           "poscode, coucode, discode, email, connotepre, insper, insperfra, insminamt, minchaamt, contact, telpre, telno, faxpre, faxno, conope, slclotime, selected, regcust, " +
                           "glno, inscover, remarks, slotbook, bolprefix, holdgrn, holdrea, anote, nbl, fclinscover, fclinsper, fclinsperfra, fclinsminamt, fclstampduty, fclgovtax, memo, fcltermday, " +
                           "customcode, salperson, faxattn, markup, mpercent, byshipmea, allowvariance, cashbill, svbyemail, svbyfax, acccode, accid, billage, billbr, createdby, createddate, " +
                           "lastmodifiedby, lastmodifieddate, vip, minfrtrate, userreportprint, reportprintdate, reportprintby, hakgerakandate, svconsignee, autovesselsc, emailvesselsc, " +
                           "custgradecode, IsExportShprDO, mobilepre, mobileno, ExpiryDateFrom, ExpiryNoOfDays, ExpiryStatus, DateTimeInserted, DateTiemUpdated, HostNameIPAddress, " +
                           "OnUse, OnUseBy " +
                   "FROM Customers " +
                   "WHERE ExpiryStatus <> 0";
        }


        public void Dispose()
        {
            GC.Collect();
           // throw new NotImplementedException();
        }
    }
}
